SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 57203: The VALIDVARNAME=ANY system option is not honored when specified prior to PROC IMPORT

DetailsAboutRate It

The VALIDVARNAME=ANY system option is ignored when it is specified in an OPTIONS statement before a PROC IMPORT step. Instead of honoring the VALIDVARNAME=ANY option, PROC IMPORT treats variable names that contain special characters as part of the name as if VALIDVARNAME=V7 was specified.

For example, a variable name of "test 1" is created as test_1 instead of "test 1"n when the VALIDVARNAME=ANY option is specified prior to PROC IMPORT.

There is currently no circumvention for this issue.

Beginning in SAS® 9.4, the VALIDVARNAME=ANY option is honored when it is specified prior to PROC IMPORT.



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemBase SASMicrosoft® Windows® for x649.3 TS1M09.4 TS1M0
Microsoft Windows Server 2003 Datacenter Edition9.3 TS1M0
Microsoft Windows Server 2003 Enterprise Edition9.3 TS1M0
Microsoft Windows Server 2003 Standard Edition9.3 TS1M0
Microsoft Windows Server 2003 for x649.3 TS1M0
Microsoft Windows Server 20089.3 TS1M0
Microsoft Windows Server 2008 R29.3 TS1M09.4 TS1M0
Microsoft Windows Server 2008 for x649.3 TS1M09.4 TS1M0
Microsoft Windows XP Professional9.3 TS1M0
Windows 7 Enterprise 32 bit9.3 TS1M0
Windows 7 Enterprise x649.3 TS1M09.4 TS1M0
Windows 7 Home Premium 32 bit9.3 TS1M0
Windows 7 Home Premium x649.3 TS1M0
Windows 7 Professional 32 bit9.3 TS1M0
Windows 7 Professional x649.3 TS1M09.4 TS1M0
Windows 7 Ultimate 32 bit9.3 TS1M0
Windows 7 Ultimate x649.3 TS1M0
Windows Vista9.3 TS1M0
Windows Vista for x649.3 TS1M0
64-bit Enabled AIX9.3 TS1M09.4 TS1M0
64-bit Enabled HP-UX9.3 TS1M09.4 TS1M0
64-bit Enabled Solaris9.3 TS1M09.4 TS1M0
HP-UX IPF9.3 TS1M09.4 TS1M0
Linux9.3 TS1M09.4 TS1M0
Linux for x649.3 TS1M09.4 TS1M0
Solaris for x649.3 TS1M09.4 TS1M0
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.